system tables - Mailing list pgsql-novice

From M. Bastin
Subject system tables
Date
Msg-id a06020424bc6bc5831ed8@[192.168.0.101]
Whole thread Raw
In response to Re: Column Headings using Comment?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: system tables
List pgsql-novice
Hi,

I've spent several hours browsing the system tables and the online
documentation about them but I still can't find how to extract
following information:

1. How do I find the user name for a given pid?

2. Where's the list that links all valid text encoding names with the
numbers representing them?  (E.g. UNICODE = 6)

Is there an easy way to recoup how the different system tables are
related to each other, or does one simply have to know?

Thanks,

Marc

pgsql-novice by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: UPDATE FROM syntax
Next
From: Scott Goodwin
Date:
Subject: Merging multiple values into comma-delimited list in a view